Chapter No 1 :MS Excel Basic Level (63 MCQ`S)

  1. Microsoft Excel is an excellent program for
    1. Organizing
    2. Formatting
    3. Calculating
    4. All
    5. Show Answer
      Answer: D
      Explanation:
      • Microsoft Excel 2016 is an excellent program for organizing, formatting, and calculating numeric data.
  2. Excel displays data in ___________________ format
    1. Row
    2. Column
    3. Both
    4. None
    5. Show Answer
      Answer: C
      Explanation:
      • Excel displays data in a row-and-column format, with gridlines between them.
  3. Excel wrok sheet is similar to
    1. Ledger Book
    2. Graph Paper
    3. Both
    4. None
    5. Show Answer
      Answer: C
      Explanation:
      • Excel Sheet is similar to accounting ledger books or graph paper.
  4. By default Microsoft Excel 2016 file extension is
    1. .xls
    2. .xlsx
    3. .xlsm
    4. .xps
    5. Show Answer
      Answer: B
      Explanation:
      • Excel 2016 by default file extension is .xlsx
  5. A Microsoft Excel book1 (workbook) consists
    1. Worksheets
    2. Rows
    3. Columns
    4. None
    5. Show Answer
      Answer: A
      Explanation:
      • A Microsoft Excel book1 (workbook) consists of sheet(s) or worksheet(s).
  6. The columns are lettered A to Z and then continuing with AA, AB, AC and so on to ___
    1. XDF
    2. FDX
    3. XFD
    4. None
    5. Show Answer
      Answer: C
      Explanation:
      • The columns are lettered A to Z and then continuing with AA, AB, AC and so on to XFD
  7. In MS Excel the rows are numbered 1 to _____________
    1. 1048576
    2. 1046576
    3. 12536
    4. 1047675
    5. Show Answer
      Answer: A
      Explanation:
      • The rows are numbered 1 to 1,048,576
  8. Dialog box launcher is located in the ___________location
    1. Bottom Left
    2. Bottom Right
    3. Bottom Center
    4. None
    5. Show Answer
      Answer: B
      Explanation:
      • Dialog box launcher is located in the bottom right corner of the group.
  9. When we select a specific object like shape, chart, picture etc. in Excel the extra tab appear on the ribbon is called
    1. Contextual Tab
    2. Format tab
    3. Design Tab
    4. Layout Tab
    5. Show Answer
      Answer: A
      Explanation:
      • When we select a specific object like shape, chart, picture etc. in Excel the extra tab appear on the ribbon is called contextual tab.
  10. The most frequently used commands in excel contained on the quick access tool bar located on ______ corner
    1. Top Left
    2. Top Center
    3. Top Right
    4. Bottom
    5. Show Answer
      Answer:
      Explanation:
      • The most frequently used commands in excel contained on the quick access tool bar located on Left corner

COMING SOON

  1. FINE ARTS
  2. HOME ECONOMICS
  3. JOURNALISM
  4. PHILOSOPHY
  5. SARAIKI(سرائیکی)
  6. SOCIAL WORK